﻿CREATE TABLE [dbo].[Users]
(
	[EmployeeID]		INT    NOT NULL,
	[UserId]            VARCHAR (20) NOT NULL,
	[Password]          VARCHAR (200) NOT NULL, -- validation gui has to GUI has to be done based on 20 , length increse due to encrption
	[RoleID]            INT         NOt NULL,
	[TxnCrUser]         VARCHAR (20)          NULL,
	[TxnCrDate]         DATETIME     NULL,
	[TxnUser]           VARCHAR (20)          NULL,
	[Txndate]           DATETIME     NULL
)
go
ALTER TABLE [dbo].[Users]
	ADD CONSTRAINT [PK_Users]
	PRIMARY KEY ([EmployeeID])
